ETL Developer

Daily and monthly responsibilities

• Review and coordinate with business application teams on data delivery requirements.
• Develop estimation and proposed delivery schedules in coordination with development team.
• Develop sourcing and data delivery designs.
• Review data model, metadata and delivery criteria for solution.
• Review and coordinate with team on test criteria and performance of testing.
• Contribute to the design, development and completion of project deliverables.
• Complete in-depth data analysis and contribution to strategic efforts
• Complete understanding of how we manage data with focus on improvement of how data is sourced and managed across multiple business areas.

Basic Qualifications

• Bachelor’s degree.
• 5+ years of data analysis working with business data initiatives.
• Knowledge of Structured Query Language (SQL) and use in data access and analysis.
• Proficient in data management including data analytical capability.
• Excellent verbal and written communications also high attention to detail.
• Experience with Python.
• Presentation skills in demonstrating system design and data analysis solutions.

Intuitive cloud (http://www.intuitive.cloud">www.intuitive.cloud) is one of the fastest growing top-tier Cloud Solutions and SDx Engineering solution and service company supporting 80+ Global Enterprise Customer across Americas, Europe and Middle East.

Intuitive is a recognized professional and manage service partner for core superpowers in cloud(public/ Hybrid), security, GRC, DevSecOps, SRE, Application modernization/ containers/ K8 -as-a- service and cloud application delivery.

• 9+ years’ experience as data engineer.
• Must have 4+ Years in implementing data engineering solutions with Databricks.
• This is hands on role building data pipelines using Databricks. Hands-on technical experience with Apache Spark.
• Must have deep expertise in one of the programming languages for data processes (Python, Scala). Experience with Python, PySpark, Hadoop, Hive and/or Spark to write data pipelines and data processing layers
• Must have worked with relational databases like Snowflake. Good SQL experience for writing complex SQL transformation.
• Performance Tuning of Spark SQL running on S3/Data Lake/Delta Lake/ storage and Strong Knowledge on Databricks and Cluster Configurations.
• Hands on architectural experience
• Nice to have Databricks administration including security and infrastructure features of Databricks.

• Proficient with SQL Server/T-SQL programming in creation and optimization of complex Stored Procedures, UDF, CTE and Triggers
• Overall Experience should be between 4 to 7 years
• Experience working in a data warehouse environment and a strong understanding of dimensional data modeling concepts. Experience in SQL server, DW principles and SSIS.
• Should have strong experience in building data transformations with SSIS including importing data from files, and moving data from source to destination.
• Creating new SSIS packages or modifying existing SSIS packages using SQL server
• Debug and fine-tune SSIS processes to ensure accurate and efficient movement of data. Experience with ETL testing & data validation.
• 1+ years of experience with Azure services like Azure Data Factory, Data flow, Azure blob Storage, etc.
• 1+ years of experience with developing Azure Data Factory Objects - ADF pipeline, configuration, parameters, variables, Integration services runtime.
• Must be able to build Business Intelligence solutions in a collaborative, agile development environment.
• Reporting experience with Power BI or SSRS is a plus.
• Experience working on an Agile/Scrum team preferred.
• Proven strong problem-solving skills, troubleshooting, and root cause analysis.
• Excellent written and verbal communication skills.

About us

SteelEye is the only regulatory compliance technology and data analytics firm that offers transaction reporting, record keeping, trade reconstruction, best execution and data insight in one comprehensive solution. The firm’s scalable secure data storage platform offers encryption at rest and in flight and best-in-class analytics to help financial firms meet regulatory obligations and gain competitive advantage.

The company has a highly experienced management team and a strong board, who have decades of technology and management experience and worked in senior positions at many leading international financial businesses. We are a young company that shares a commitment to learning, being smart, working hard and being honest in all we do and striving to do that better each day. We value all our colleagues equally and everyone should feel able to speak up, propose an idea, point out a mistake and feel safe, happy and be themselves at work.

Being part of a start-up can be equally exciting as it is challenging. You will be part of the SteelEye team not just because of your talent but also because of your entrepreneurial flare which we thrive on at SteelEye. This means we want you to be curious, contribute, ask questions and share ideas. We encourage you to get involved in helping shape our business. What you'll do

What you will do?

• Deliver plugins for our python based ETL pipelines.
• Deliver python services for provisioning and managing cloud infrastructure.
• Design, Develop, Unit Test, and Support code in production.
• Deal with challenges associated with large volumes of data.
• Manage expectations with internal stakeholders and context switch between multiple deliverables as priorities change.
• Thrive in an environment that uses AWS and Elasticsearch extensively.
• Keep abreast of technology and contribute to the evolution of the product.
• Champion best practices and provide mentorship.

What we're looking for

• Python 3.
• Python libraries used for data (such as pandas, numpy).
• AWS.
• Elasticsearch.
• Performance tuning.
• Object Oriented Design and Modelling.
• Delivering complex software, ideally in a FinTech setting.
• CI/CD tools.
• Knowledge of design patterns.
• Sharp analytical and problem-solving skills.
• Strong sense of ownership.
• Demonstrable desire to learn and grow.
• Excellent written and oral communication skills.
• Mature collaboration and mentoring abilities.

What will you get?

• This is an individual contributor role. So, if you are someone who loves to code and solve complex problems and build amazing products and not worry about anything else, this is the role for you.
• You will have the chance to learn from the best in the business who have worked across the world and are technology geeks.
• Company that always appreciates ownership and initiative. If you are someone who is full of ideas, this role is for you.

Pingahla is recruiting business intelligence Consultants/Senior consultants who can help us with Information Management projects (domestic, onshore and offshore) as developers and team leads. The candidates are expected to have 3-6 years of experience with Informatica Power Center/Talend DI/Informatica Cloud and must be very proficient with Business Intelligence in general. The job is based out of our Pune office.

Responsibilities:

• Manage the customer relationship by serving as the single point of contact before, during and after engagements.
• Architect data management solutions.
• Provide technical leadership to other consultants and/or customer/partner resources.
• Design, develop, test and deploy data integration solutions in accordance with customer’s schedule.
• Supervise and mentor all intermediate and junior level team members.
• Provide regular reports to communicate status both internally and externally.
• Qualifications:
• A typical profile that would suit this position would be if the following background:
• A graduate from a reputed engineering college 
• An excellent I.Q and analytical skills and should be able to grasp new concepts and learn new technologies.
• A willingness to work with a small team in a fast-growing environment.
• A good knowledge of Business Intelligence concepts

Mandatory Requirements:

• Knowledge of Business Intelligence
• Good knowledge of at least one of the following data integration tools - Informatica Powercenter, Talend DI, Informatica Cloud
• Knowledge of SQL
• Excellent English and communication skills
• Intelligent, quick to learn new technologies
• Track record of accomplishment and effectiveness with handling customers and managing complex data management needs