Typical Day in Role:
• You will write well designed, testable, efficient code by using best software development practices
• You will gather and refine specifications and requirements based on technical needs
• Create and maintain software documentation
• Develop strategies for Extraction, Transformation and Loading (ETL)mechanism.
• Design Server jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, Link Partitioner and Link Collector.
• Analyze the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Study the data dependencies using metadata stored in the repository and prepared batches for the existing sessions to facilitate scheduling of multiple sessions.
• Direct day-to-day activities in a manner consistent with our risk culture and the relevant risk appetite statement and limits and communicate it throughout the team.
• Create an environment in which your team pursues effective and efficient operations of their respective areas while ensuring the adequacy, adherence to and effectiveness of day-to-day business controls to meet obligations with respect to risk and compliance
Candidate Requirements/Must-Have skills:
• Overall 10+ years of experience in development with at least 5+ years of deep experience creating and supporting ETL integrations (batch and real-time)
• You have 3+ years of experience Hands-on experience with Parallel jobs like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XM
• You have 3+ years of hands-on experience with DataStage Manager, Designer, Administrator, and Director
• You have 3+ years of hands-on experience with Big Data concept and platforms, such as Hadoop/ Hive/Beeline/EDL
• You are an expert in UNIX shell scripts using K-shell for the automation of processes and scheduling DataStage jobs
Nice-To-Have Skills:
• You have Data Warehousing skills and experience in dimensional modeling.
• You have experience in Data Modeling as well as reverse engineering using tools like Erwin and MS Visio as an asset.
• You have experience in integration of various data sources (DB2-UDB, PL/SQL, Hadoop data) into data staging area.
• You have experience in performance tuning and enhancement as an asset.
Soft Skills:
• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently with minimal direction.
Education:
Bachelors in computer science or comp engineer